﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace BKIDS.CDBNames
{
    public enum e_loai_tu_dien
    { 
        PHAN_QUYEN = 1,
        DM_NGANH_HOC =2,
        DM_TRANG_THAI_DU_AN = 3,
        DM_LOAI_DU_AN = 4,
        DM_LOAI_CONG_VIEC = 5,
        DM_VAI_TRO = 6,
        DM_CHUC_VU = 7,
        DM_VI_TRI_DU_AN = 8,
        DM_TRANG_THAI_CONG_VIEC = 9
        
    }

    public enum e_user_group
    {
        TESTER = 1,
        PM_TD = 2,
        TRUONG_NHOM_PO = 3,
        PO = 4,
        ADMIN = 5, 
        GIANG_VIEN = 6
    }

    public class CM_DM_LOAI_TD
    {
        public const string ID = "ID";
        public const string MA_LOAI = "MA_LOAI";
        public const string TEN_LOAI = "TEN_LOAI";
    }


    public class CM_DM_TU_DIEN
    {
        public const string ID = "ID";
        public const string MA_TU_DIEN = "MA_TU_DIEN";
        public const string ID_LOAI_TU_DIEN = "ID_LOAI_TU_DIEN";
        public const string TEN_NGAN = "TEN_NGAN";
        public const string TEN = "TEN";
        public const string GHI_CHU = "GHI_CHU";
    }

    public class DM_CHI_PHI_LOP_HOC
    {
        public const string ID = "ID";
        public const string MA_CHI_PHI = "MA_CHI_PHI";
        public const string TEN_CHI_PHI = "TEN_CHI_PHI";
        public const string DON_GIA_DEFAULT = "DON_GIA_DEFAULT";
        public const string DON_VI_TINH = "DON_VI_TINH";
        public const string THU_CHI_YN = "THU_CHI_YN";
        public const string GHI_CHU = "GHI_CHU";
    }

    public class DM_CHI_TIET_DU_AN
    {
        public const string ID = "ID";
        public const string ID_DU_AN = "ID_DU_AN";
        public const string ID_CONG_VIEC = "ID_CONG_VIEC";
        public const string TUAN_HOC = "TUAN_HOC";
        public const string HE_SO = "HE_SO";
        public const string ID_DOI_TUONG = "ID_DOI_TUONG";
        public const string ID_TRANG_THAI_CONG_VIEC = "ID_TRANG_THAI_CONG_VIEC";
        public const string NOI_DUNG = "NOI_DUNG";
        public const string DEADLINE = "DEADLINE";
        public const string NGAY_CAP_NHAT = "NGAY_CAP_NHAT";
        public const string GHI_CHU = "GHI_CHU";
    }

    public class DM_CONG_VIEC_DU_AN
    {
        public const string ID = "ID";
        public const string TEN_CONG_VIEC = "TEN_CONG_VIEC";
        public const string ID_LOAI_DU_AN = "ID_LOAI_DU_AN";
        public const string ID_LOAI_CONG_VIEC = "ID_LOAI_CONG_VIEC";
        public const string MA_DON_VI_TINH = "MA_DON_VI_TINH";
        public const string HE_SO_DEFAULT = "HE_SO_DEFAULT";
        public const string GHI_CHU = "GHI_CHU";
    }

    public class DM_DOI_TUONG
    {
        public const string ID = "ID";
        public const string MA_DOI_TUONG = "MA_DOI_TUONG";
        public const string HO_VA_TEN_DEM = "HO_VA_TEN_DEM";
        public const string TEN = "TEN";
        public const string NGAY_SINH = "NGAY_SINH";
        public const string GIOI_TINH_YN = "GIOI_TINH_YN";
        public const string QUE_QUAN = "QUE_QUAN";
        public const string DIA_CHI_HIEN_TAI = "DIA_CHI_HIEN_TAI";
        public const string DIEN_THOAI = "DIEN_THOAI";
        public const string EMAIL_CA_NHAN = "EMAIL_CA_NHAN";
        public const string ANH_CA_NHAN = "ANH_CA_NHAN";
        public const string KHOA_NGANH = "KHOA_NGANH";
        public const string TRUONG_DAO_TAO = "TRUONG_DAO_TAO";
        public const string SO_TAI_KHOAN = "SO_TAI_KHOAN";
        public const string TEN_NGAN_HANG = "TEN_NGAN_HANG";
        public const string SO_CMND = "SO_CMND";
        public const string NGAY_CAP = "NGAY_CAP";
        public const string NOI_CAP = "NOI_CAP";
        public const string GIOI_THIEU = "GIOI_THIEU";
    }

    public class DM_DU_AN
    {
        public const string ID = "ID";
        public const string TEN_DU_AN = "TEN_DU_AN";
        public const string ID_MON_HOC = "ID_MON_HOC";
        public const string ID_LOAI_DU_AN = "ID_LOAI_DU_AN";
        public const string ID_TRANG_THAI_DU_AN = "ID_TRANG_THAI_DU_AN";
        public const string NGAY_BAT_DAU = "NGAY_BAT_DAU";
        public const string DEADLINE = "DEADLINE";
        public const string GHI_CHU = "GHI_CHU";
    }

    public class DM_GIANG_VIEN
    {
        public const string ID = "ID";
        public const string TEN_DANG_NHAP = "TEN_DANG_NHAP";
        public const string MAT_KHAU = "MAT_KHAU";
        public const string EMAIL_BKINDEX = "EMAIL_BKINDEX";
        public const string NGAY_DAU_CONG_TAC = "NGAY_DAU_CONG_TAC";
        public const string NOI_CONG_TAC = "NOI_CONG_TAC";
        public const string HOC_VI = "HOC_VI";
    }

    public class DM_HOC_VIEN
    {
        public const string ID = "ID";
        public const string TEN_DANG_NHAP = "TEN_DANG_NHAP";
        public const string MAT_KHAU = "MAT_KHAU";
        public const string ID_LOAI_HV = "ID_LOAI_HV";
    }

    public class DM_LOAI_HOC_VIEN
    {
        public const string ID = "ID";
        public const string TEN_LOAI_HV = "TEN_LOAI_HV";
        public const string HE_SO_GIAM_HOC_PHI = "HE_SO_GIAM_HOC_PHI";
        public const string MO_TA = "MO_TA";
        public const string GHI_CHU = "GHI_CHU";
    }

    public class DM_LOP_MON
    {
        public const string ID = "ID";
        public const string MA_LOP_MON = "MA_LOP_MON";
        public const string ID_MON_HOC = "ID_MON_HOC";
        public const string NGAY_BAT_DAU = "NGAY_BAT_DAU";
        public const string NGAY_KET_THUC = "NGAY_KET_THUC";
        public const string NGAY_KHAI_GIANG = "NGAY_KHAI_GIANG";
        public const string SO_LUONG_OFFLINE = "SO_LUONG_OFFLINE";
        public const string SO_LUONG_ONLINES = "SO_LUONG_ONLINES";
        public const string ID_PHONG_HOC = "ID_PHONG_HOC";
        public const string KIP_HOC = "KIP_HOC";
        public const string GHI_CHU = "GHI_CHU";
    }

    public class DM_MON_HOC
    {
        public const string ID = "ID";
        public const string MA_MON_HOC = "MA_MON_HOC";
        public const string TEM_MON_HOC = "TEM_MON_HOC";
        public const string ID_NGANH_HOC = "ID_NGANH_HOC";
        public const string SO_TUAN_HOC = "SO_TUAN_HOC";
        public const string GHI_CHU = "GHI_CHU";
    }

    public class DM_PHONG_HOC
    {
        public const string ID = "ID";
        public const string TEN_PHONG_HOC = "TEN_PHONG_HOC";
        public const string DIA_CHI = "DIA_CHI";
        public const string GHI_CHU = "GHI_CHU";
    }

    public class DM_THANH_VIEN
    {
        public const string ID = "ID";
        public const string TEN_DANG_NHAP = "TEN_DANG_NHAP";
        public const string ID_CHUC_VU = "ID_CHUC_VU";
        public const string MAT_KHAU = "MAT_KHAU";
        public const string EMAIL_BKINDEX = "EMAIL_BKINDEX";
        public const string NGAY_VAO_ELEARNING = "NGAY_VAO_ELEARNING";
    }

    public class GD_DOI_TUONG_DU_AN
    {
        public const string ID = "ID";
        public const string ID_DU_AN = "ID_DU_AN";
        public const string ID_DOI_TUONG = "ID_DOI_TUONG";
        public const string ID_VAI_TRO = "ID_VAI_TRO";
        public const string GHI_CHU = "GHI_CHU";
    }

    public class GD_DOI_TUONG_LOP_HOC
    {
        public const string ID = "ID";
        public const string ID_LOP_MON = "ID_LOP_MON";
        public const string ID_DOI_TUONG = "ID_DOI_TUONG";
        public const string ID_VAI_TRO = "ID_VAI_TRO";
        public const string GHI_CHU = "GHI_CHU";
        public const string NGAY_CAP_NHAT = "NGAY_CAP_NHAT";
    }

    public class GD_LICH_SU_THANH_VIEN
    {
        public const string ID = "ID";
        public const string ID_THANH_VIEN = "ID_THANH_VIEN";
        public const string ID_CHUC_VU = "ID_CHUC_VU";
        public const string NGAY_BAT_DAU = "NGAY_BAT_DAU";
        public const string NGAY_KET_THUC = "NGAY_KET_THUC";
        public const string GHI_CHU = "GHI_CHU";
    }

    public class GD_THU_CHI_LOP_HOC
    {
        public const string ID = "ID";
        public const string ID_LOP_HOC = "ID_LOP_HOC";
        public const string ID_ND_THU_CHI = "ID_ND_THU_CHI";
        public const string SO_TIEN = "SO_TIEN";
        public const string ID_DOI_TUONG_THANH_TOAN = "ID_DOI_TUONG_THANH_TOAN";
        public const string TRANG_THAI_YN = "TRANG_THAI_YN";
        public const string NGAY_CAP_NHAT = "NGAY_CAP_NHAT";
        public const string GHI_CHU = "GHI_CHU";
    }


    public class HT_NGUOI_SU_DUNG
    {
        public const string ID = "ID";
        public const string TEN_TRUY_CAP = "TEN_TRUY_CAP";
        public const string TEN = "TEN";
        public const string MAT_KHAU = "MAT_KHAU";
        public const string NGAY_TAO = "NGAY_TAO";
        public const string NGUOI_TAO = "NGUOI_TAO";
        public const string TRANG_THAI = "TRANG_THAI";
        public const string BUILT_IN_YN = "BUILT_IN_YN";
        public const string ID_USER_GROUP = "ID_USER_GROUP";
        public const string ID_TRAINING_PROJECT = "ID_TRAINING_PROJECT";
    }

    public class V_DM_THANH_VIEN
    {
        public const string ID = "ID";
        public const string TEN_DANG_NHAP = "TEN_DANG_NHAP";
        public const string HO_VA_TEN = "HO_VA_TEN";
        public const string ID_CHUC_VU = "ID_CHUC_VU";
        public const string TEN_CHUC_VU = "TEN_CHUC_VU";
        public const string MAT_KHAU = "MAT_KHAU";
        public const string EMAIL_BKINDEX = "EMAIL_BKINDEX";
        public const string NGAY_VAO_ELEARNING = "NGAY_VAO_ELEARNING";
    }

}
